package com.lingnan.club.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.lingnan.club.pojo.User;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface UserMapper extends BaseMapper<User> {

    /*直接根据是否有打卡确定在不在线*/
    @Select("select u.* from tb_user u ,tb_pushRecord r where u.id = r.r_id and u.is_pushcard !=0")
    List<User> findOnlineUser();

    @Select("select * from tb_user where is_sign != sign_id ")
    List<User> findFailSignRecord0();

}
